package com.hngy.educationaladministration.mapper;

import com.hngy.educationaladministration.entity.Score;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Author: 秃头不用洗发水
 * @Date: 2021-06-04
 * @Description:
 */
@Repository
public interface ScoreMapper {

    @Insert("insert into t_score(pid, tid, fid, score)\n" +
            "values (#{pid}, #{tid}, #{fid}, #{score})")
    int insertScore(Score score);

    @Select("select * from t_score where fid = #{fid}")
    Score getScoreByFid(Integer fid);
}
